package com.sto.stoapp.db.constant;

public interface StoSiteCodeConstant extends StoBaseConstant {


	public static final String BACKUP1 = "backup1";

	
	public static final int DESTINATION_LENGTH=8;
	/**
	 * 下一站长度
	 */
	public final int NEXT_STATION_LENGTH = 6;
	/**
	 * 网点编号
	 */
	public static final String SITE_CODE_NUMBER = "site_code_number";

	/**
	 * 网点名称
	 */
	public static final String SITE_CODE_NAME = "site_code_name";

	/**
	 * 网点全表名
	 */
	public static final String SITE_CODE_FULL_TABLE = "site_code_full_table";

	/**
	 * 下一站网点资料表名
	 */
	public static final String NEXT_SITE_CODE_TABLE = "next_site_code_table";

	/**
	 * 创建网点编号全表
	 */
	public static final String CREATE_SITE_FULL_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ SITE_CODE_FULL_TABLE
			+ "("
			+ "id  text PRIMARY KEY "
			+ ","
			+ SITE_CODE_NUMBER
			+ " char(6)"
			+ ","
			+ SITE_CODE_NAME
			+ " char(20)"
			+ ","
			+ VERSION
			+ " text "
			+ ","
			+ BACKUP1
			+ " text "
			+ ","
			+STATUS
			+" text "
			+","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ "," + BACKUPS_THREE + " char(50)" + ")";

	/**
	 * 删除网点编号全表
	 */
	public static final String DROP_SITE_FULL_TABLE = "drap table if exists "
			+ SITE_CODE_FULL_TABLE;

	/**
	 * 创建下一站网点资料表
	 */
	public static final String CREATE_NEXT_SITE_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ NEXT_SITE_CODE_TABLE
			+ "("
			+ "id  text PRIMARY KEY "
			+ ","
			+ SITE_CODE_NUMBER
			+ " char(6)"
			+ ","
			+ SITE_CODE_NAME
			+ " char(20)"
			+ ","
			+ VERSION
			+ " text "
			+ ","
			+STATUS
			+" text "
			+","
			+ BACKUP1
			+ " text "
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ "," + BACKUPS_THREE + " char(50)" + ")";

	/**
	 * 删除下一站网点资料表
	 */
	public static final String DROP_NEXT_SITE_TABLE = "drop table if exists "
			+ NEXT_SITE_CODE_TABLE;
}
